A Capacity Planning Study of Database Management Systems with OLAP Workloads
نویسنده
چکیده
...................................................................................................... i Acknowledgements.................................................................................... iii
منابع مشابه
Benchmarking Hybrid OLTP&OLAP Database Systems
Recently, the case has been made for operational or real-time Business Intelligence (BI). As the traditional separation into OLTP database and OLAP data warehouse obviously incurs severe latency disadvantages for operational BI, hybrid OLTP&OLAP database systems are being developed. The advent of the first generation of such hybrid OLTP&OLAP database systems requires means to characterize their...
متن کاملParallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads
Modern in-memory database systems are facing the need of efficiently supporting mixed workloads of OLTP and OLAP. A conventional approach to this requirement is to rely on ETL-style, application-driven data replication between two very different OLTP and OLAP systems, sacrificing realtime reporting on operational data. An alternative approach is to run OLTP and OLAP workloads in a single machin...
متن کاملHyPer-sonic Combined Transaction AND Query Processing
In this demo we will prove that it is – against common belief – indeed possible to build a main-memory database system that achieves world-record transaction processing throughput and best-of-breed OLAP query response times in one system in parallel on the same database state. The two workloads of online transaction processing (OLTP) and online analytical processing (OLAP) present different cha...
متن کاملDynamic Relational Data Management for Technical Applications
Database systems are widely used in technical applications. However, it is difficult to decide which database management system fits best for a certain application. For many applications, different workload types often blend to mixed workloads that cause mixed requirements. The selection of an appropriate database management systems is more critical for mixed workloads because classical domains...
متن کاملSupporting capacity planning for DB2 UDB
Capacity planning is the process of determining the most cost-effective computing environment that meets the current and future demands of a computing system. Capacity planning is important for large database management systems (DBMSs) whose performance can be greatly affected by the amount of available resources and whose workloads can change significantly over time. In this paper, we examine ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2003